package com.ysd.ziyuanshiyongtongji.util;

import java.io.File;
import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.List;
import java.io.IOException;

import com.ysd.ziyuanshiyongtongji.model.Member;

import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/**
 * POIUtil
 */
public class POIUtil {
//导入会员信息
public static List<Member> importMember(String path) throws IOException{
    List<Member> list =new ArrayList<Member>();
    //file file=new file("c:\\users\\ause\\Desktop\\会员登记表.xlsx");
    File file=new File(path);
    //活获得该文件的输入流
    FileInputStream stream =new FileInputStream(file);
    //多态 抛异常
    Workbook sheets=new XSSFWorkbook(stream);
    //获取一个工作表（sheet页），下标从0开始
    Sheet sheet =sheets.getSheetAt(0);
    for(int i=1;i<=sheet.getLastRowNum();i++){
   //获取行数
   Row row =sheet. getRow(i);
   //获取单元格 取值
   String name =row.getCell(0).getStringCellValue();
   String sex =row.getCell(1).getStringCellValue();
   String category =row.getCell(2).getStringCellValue();
   String card =row.getCell(3).getStringCellValue();
   String department =row.getCell(4).getStringCellValue();
   String profession =row.getCell(5).getStringCellValue();
   String grade =row.getCell(6).getStringCellValue();
   String phone =row.getCell(7).getStringCellValue();
   //String remark =row.getCell(8).getStringCellValue();  
    

   Member m =new Member();
   m.setCardNo(CardUtil.getCardNo());
   m.setCard(card);
   m.setCategory(category);
   m.setDepartment(department);
   m.setGrade(grade);
   m.setName(name);
   m.setPhone(phone);
   m.setProfession(profession);
  // m.setRemark(remark);
   m.setSex(sex);
   list.add(m);
}
//关流
sheets.close();
stream.close();
return list;
}
}